package cn.gson.boot.model.dao;

import cn.gson.boot.model.pojos.Work;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

//日周月报dao
public interface WorkDao extends CrudRepository<Work,Integer> {
    //统计图查询日周月报的类型数量
    @Query(nativeQuery = true,value = "select count(*) from work_ where Work_type=?1")
    public Integer workleixing(String LX);

    //统计图查询日周月报的员工提交者
    @Query(nativeQuery = true,value = "select count(*) from work_ where emp_id=?1")
    public Integer kehufuzeren(Integer FZ);
}
